Nic Larsen ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	41

About Me

About Me

Not much happening here, yet.

Analytics

524

Posts

2,440

Visits

11.4k

Points

Jun 26, 2018

Join Date

Feb 27, 2025

Last Active

Reactions

• Insightful 11

  11
• Vote Up 29

  29
• Awesome 57

  57

• Activity
• Discussions2
• Comments522

• Re: COUNTIFS, HAS, and CONTAINS Formulas with Different Reference Sheets and Dropdowns!

  Nic Larsen

  01/29/25
  Try it like this: =COUNTIFS({Fall Nominations Range 2}, "WC", {Fall Nominations Range 7}, HAS(@cell, "Completed")
  1 ·

• Re: CONTAINS formula with contact cell

  Nic Larsen

  01/29/25
  Try using Has: =IF(HAS(Collaborateurs@row; "Frederique Goulet"); "True"; "False")
  1 ·

• Re: Countif not containing specific text

  Nic Larsen

  04/02/19
  Try this: =COUNTIFS([Aging]:[Aging], "Red", Project:Project, NOT(FIND("spring", LOWER(@cell)) >0))
  2 ·

• Re: Formule Check box avec children

  Nic Larsen

  01/06/25
  =COUNTIF(CHILDREN(), 1) > 0
  1 ·

• Re: Can't get IF formula to work,

  Nic Larsen

  01/03/25
  =IF([Column 2]@row > [Column 1]@row, 1, 0)
  1 ·

Next